home *** CD-ROM | disk | FTP | other *** search
- /*
- * the view definition is equivalent to the following commands:
- */
- create toyemp2(name = char16, age = int4, location = point, annualsal = int4)
- \g
- define rewrite rule toyemp2_ret is
- on retrieve to toyemp2 do instead
- retrieve(emp.name, emp.age, emp.location, annualsal = 12*emp.salary)
- where emp.dept = "toy"
- \g
-